Magnificent 18th-century frescoes and awe-inspiring views: where better to wind down after a busy day?