I agree - the historic district is the way to go. There are many hotels there - the chains and B&Bs. Fantastic food (Mrs Wilkes, Lady and Sons (Paula Deen) and Pirate House are the famous buffets but there are lots of places to try), River Street, the trolley tours... as mentioned - try a ghost tour! (we did the one where you ride in a hearse). Lots to do, and it is just a beautiful place to walk around.