Booking a hotel with a water park provides fun for the whole family. Those staying at the hotel can generally use the hotel's on-site water park or a water park located close by. Access to the water park is free at some properties and others may charge a nominal fee. Pack the water wings and enjoy a wonderful getaway to Palmyra: swimming pools, waterfalls and waterslides await.