Your car is leaking yellow rusty water Does a radiator leak normally give out that type of water?

Yes, this sounds like coolant from a cooling system that has been neglected and not flushed and changed regularly. Have the leak fixed, a new thermostat installed, a fresh mix of 50/50 coolant installed, and bleed the system.