Have a 1994 grandam Replaced the theromstate drive for a while then the temp hand goes to overheated stop and wait for it to cool add water and it is fine should I use antifreeze or water?

It is always better to use a water antifreeze mix because of the corrosion inhibitors in the anti freeze. Check that the cooling system hasn't got an airlock after changing the thermostat, make sure thermostat isn't upside down. Often get an airlock in the heating part of the water system, there should be a bleed screw in the engine compartment between the engine and the heater unit. Air locks are a common problem when refilling the cooling system and will lead to overheating as prevents proper circulation.