A well-known York brewery has one of the best pubs in the city, according to the local branch of CAMRA.