We enjoy visiting Charleston, but have never stayed there.
So many things to see and do. In addition to those mentioned, Patriot's point, on the Mt. Pleasant side is where tours to Ft Sumpter leave plus is the location of the USS Yorktown, a WWII aircraft carrier open for tours.
Back across the river is the SC Aquarium, not large, but good for an afternoon. Also in town is is the Charleston City Market, The Old Exchange and Provost building, Rainbow Row, and for fans of Gershwin - the original Catfish Row, originally called Cabbage Row. There are many walking and riding tours - info at the visitor's center.
There are a number of museums, several devoted to the history of slavery in the area and some covering the Civil War. One unique museum is the home of the CSS Hunley. The first manned submarine. I've not toured it, but they have on display the actual sub that was recovered in Charleston Harbor.
Charleston is a food lovers mecca. For a taste of low country cooking in a casual down home place try Jestine's Kitchen. Another one of my favorites and the best shrimp and grits I've ever tried is Poogan's Porch. If you venture across the river to visit Ft Sumpter, head of Hwy 17 to try Jack's Cosmic Dogs. Excellent hot dogs and I think they still have real barrel root beer.
Go and enjoy.
Looking forward to new adventures and new friends.