Rooms at Little Cayman Beach Resort are inches from the water (Brooke Slezak)