Magical Fountain This fountain in Waterfront Park in Charleston is a great place to cool off on these hot summer days and nights. It’s a magical place and fun as well.