Pineapple Fountain Charleston is full of beautiful fountains. The Pineapple Fountain in Waterfront Park is a welcoming (which the pineapple symbolizes) favorite. On hot summer days, it’s a great spot in which to cool your feet.