The Charleston metro area is a good area because we have three counties in which to seek teaching jobs. In Summerville, the dominant school district is Dorchester County District II.
Summerville is a perfect place to raise kids, I raised two myself there.
Best Schools in South Carolina - SC School Rankings this website will help rank the schools, you can drill it down not only to help decide where you want your kids to go, but it may help as a guide to your husband's employment.