Staying in a hotel with a water park offers fun for everyone in your family. Those staying at the hotel can generally use the hotel's water park on site or a water park nearby. Access to the water park is free at some properties and others may charge a modest fee. Pack your swimsuits and enjoy a great trip to North Charleston: wave pools, waterfalls and water playgrounds await.