The most common cause of overheating is a thermostat stuck in the closed position. Other causes of overheating could be a clogged radiator, faulty water pump, a faulty radiator fan relay, a faulty radiator fan motor, no coolant or low coolant level.
You're sure it is water and not brake fluid coming from the master cylinder?
try switching the 2 heater hoses around, they may be backwards
A possible problem could be you power wire is pinched somewhere causing it to touch a ground which will blow the fuse.
There could be a problem with the power of common ground to the Cavalier light and sun roof. Check the fuses and wiring for the problem.
Check the heating elements in the water heater. These may be bad and need replaced.
Either the linkage from the temp control unit to the valve on the heater core (which is behind the radio and temp controls) or it is the heater core itself.
Is it water or coolant? If it's water, you probably have a leaky windshield seal. If it's coolant you could have a heater control valve leak.
A coolant leak on a 93 cavalier could be anyplace where coolant flows. Check all hoses, connections, the radiator, and heater core for any possible leak spots.
Try an engine heater or an oil heater. These are both inexpensive.
The heater valve could be failing to open for one reason or another.
It can be something as simple as that they are broken and needs to be replaced. Or the internal spring holding it could have worn out as well and also needs to be replaced.
The heater valve may not be engaging or the heater core may be blocked.