Surrounded on three sides by water, offering stunning views, charming rooms and wonderful food.