Located within Charleston's famous Waterfront Park, the Pineapple Fountain is the park's popular focal point where visitors and locals alike come to relax and even take a dip in the fountain during the summer. The fountain has a distinctive design in the shape of a pineapple that contains all the distinctive features of spending a pleasant time in the middle of the garden.