A prominent city centre street was once home to a well-loved wine bar, which promised to be "clubby rather than pubby".