A 'renowned' pub and restaurant in Usk is up for sale after more than 25 years under the same ownership.