Another charming spot in Charleston is Waterfront Park, which is home to the famous pineapple fountain:

The fountain, which is open to wading, is only part of the park. There is also another fountain feature, as well as benches providing beautiful views of both the park and the harbor.