From plush pubs with rooms to period properties, these are the best places to stay