A city centre pub and former hotel, once described as "one of the county's most favourites", has a rich history steeped dating back to the 1800s.