This is basically how we cool our house in Montana during the summers. Cold water is pumped up one well and hot water is returned down another well. It uses much less electricity than a conventional AC system.
Wow. I've thought about this, using tap water to cool the house, but it's so wasteful it was never more than a playful thought. But then the Netherlands' summers are reasonably survivable even if they make me feel shit all day and all night.