From a château in Reims to a clifftop retreat in Ibiza, these hotels capture the spirit of their surroundings in ways that feel unmistakably rooted in place