north charleston is a city in the state of south carolina