Whether you’re sightseeing in the city or exploring the countryside, these hotels are ideal for bargain breaks