Fox,
If you only have an hours, I'd have to say you're out of luck. I don't believe there is anything within a reasonable distance for you. Be nice to the S.O.
:)
On the other hand, if you really want to experience some Charleston hospitality, and you are not proud, or finicky, and don't scare easily there is always the street scene. As in most such venues, here you're likely to find cracked out femmes who will do most anything for 10 or 20 bucks. However this would be in N. Charleston which is at least an hour from where you will be staying. You could tell your S.O. that you heard that there were some good photo ops there and head out with your camera. But I'm sure it will take you at least two hours to get there, do the deed and come back.
Lex