Rocks pond to Charleston

Need suggestions for a boat trip to Charelston. We are going to leave Sunday morning and going to make it an all day affair. Any spots that I need to hit please let me know. This is a site seeing excursion only no fishing rods allowed:frowning_face:. Also, would like to know if the water front has public parking. Do I need to call for any bridge openings along the way. Any input will be appreciated. Thanks in advance.:smiley: