I use cold tap water to cool my system. It runs through a coil of plastic tubing in my sump, then out to the pond or plants that need water. For folks around here it is a great way to go as our tap water is usually quite cool.
I won't give all the model numbers as I expect they are no longer available. I put this together years ago.
The cooling uses a lab controller (a Dynasense Thermistor controller) that has a high sensitivity, but could be any hobby on/off controller.
The solenoid is just an on/off solenoid that can accept water line pressure. It is normally off unless electricity is applied. Many places sell these, such as Cole Parmer, I believe.
The solenoid is on the cold water line. It attaches to tubing from Home Depot. I'll check, but I think it is 1/4" OD polyethylene (maybe polypropylene) tubing in a big coil in the sump.
When the temp is high, water runs through the tubing, and then out to the yard. Early in the summer, when the tap water is colder, I throttle back the line pressure a bit with a valve so that the flow is lower, but later I open it up so the flow is only limited by the back pressure from the coil.
The flow is probably on the order of 1 gallon per 5 minutes when on. In my setup, it never runs more than 50% of the time, and usually much less. I only have it operating from about June until late September. The rest of the year I need heat rather than cooling.