'This is not over,' S.C. governor says of historic rain and flooding