Mike,
Don't worry, there will be plenty of opportunities to hunt here. I've lived in Charleston all my life and can honestly say that there's no where I'd rather be. I hunt the Lowcountry, but I know there's plenty of public and private land to hunt in the midlands. Two websites for you to check out:
www.dnr.sc.gov/

www.scducks.com

Contrary to what the name implies, it's a local forum that covers all aspects of fishing and hunting. Just a warning though, there are some pretty colorful folks on there and the conversations aren't exactly PC.

Good luck with the move.