Staying in a hotel with a water park provides fun for the whole family. Hotel guests can generally use the hotel's on-site water park or a water park located nearby. It's free at some properties and others may charge a modest fee. Pack the water wings and enjoy a fun-filled getaway to Fenwick Island: swimming pools, lazy rivers and waterslides await.