From serene, adults-only havens to vibrant family-friendly retreats, our pools offer an exclusive space to unwind and recharge