The Pineapple Fountain The Pineapple Fountain, in Waterfront Park, is one of the most beloved sites in Charleston. Symbolizing “welcome,” it is not only pretty cool looking, it can cool off your feet after a long day of exploring Charleston.