My brother lives in Mt. Pleasant which is across the bridge from Charleston. I suggest you look at the Sleep Inn
park and cruise deal.
There is a bit of a war going on between some citizens and businesses in Charleston and Carnival. Paul Motter wrote about it here