Waterspout that formed off Folly Beach was rated an EF0 tornado after moving onshore, forecasters say