Of course the town is beautiful. For any medium or long term mooring
I would suggest St Johns Yacht Harbor (probably one of my favourite marinas
on the east coast
at decent prices), but for a few days, stay near town.
Avoid Charleston Harbor Resort and Marina. This is on the "modern" ugly side of Charleston (Mt Pleasant), and is expensive and quite honestly a very horrible marina inmho. You are also quite exposed as hell to the elements from all sides. I would find something down the Ashely River (you can't go very far depending on your mast
height), probably City Marina is the right place to find mooring
or a dock
for a couple of days. If the weather
is good, you can anchor
out, there's a lot of boats there and you can dinghy
to the City Marina, I believe you can land there.
I would suggest (even if it implies a longer uber ride from downtown) to hit a restaurant called Wild Olive (near St Johns Yacht Harbor actually), on Johns Island. It's fantastic. Very good food
and ambience. My favourite Charleston spot for dinner. By far.