Car nose-dives into water in Cherokee County