I live in Mount Pleasant which is a suburb of Charleston.
You have a few options for your lodging, you can look at Isle of Palms or Folley Beach if you want to stay on the beach. Or you can stay downtown, in the Historic district. It would depend on what your kids like.
There's lots of good restaurants including- Coast, Rue de John, The Mustard Seed, Oak Steakhouse ( fancy places ) and I can give you lots of unfancy ones, too.
Let me know if you have specific questions.

) I think they have a prime rib special one night...There's lots of shopping on King St and a nice outdoor mall in Mount Pleasant ( The Town Centre- it also has a 16 screen theatre ) 
)Boone Hall Plantation. Middleton Plantation. Going to see the Angel Oak on Johns Island.
Taking a walk in the Market is a tourist must ( though IMO they sell mostly junk ) and walking Rainbow Row. I personally would recommend the ghost walk. It's a lot of fun and even non tourists enjoy it. But, watch the sidewalks, we see lots of trip and fall injuries from uneven cobblestone.
When you're downtown, you can have dinner at Tommy Condon's on Church St. Except for Monday and Tues they have an Irish band, who are really good ( and also friends of mine) I think they have a prime rib special one night...There's lots of shopping on King St and a nice outdoor mall in Mount Pleasant ( The Town Centre- it also has a 16 screen theatre )
If you need anything else, let me know.
, it is a great bridge to walk/run over and it is very scenic
. The battery in downtown charleston is also nice to walk. Grill 225 on eastbay at the market pavilion hotel is also lovely and in the same vicinity, you have lots of restaurant choices, like sandwich shops, seafood, candy store, arts and crafts and japenese all in walking distance too! I forgot to mention the children museum opened not too long ago and it is very neat, we also have the aquarium and it is very neat as well. 

Hymans or Ah Shucks
aquarium
Fort Sumter
We always stay at the old Citadel which they converted to a hotel. One of the chains runs it now but its still neat.