It would be a great solution for CA and the southwest, but I'm guessing the water table might be pretty deep in a lot of locations. 1500'-2500' water wells are expensive.  Rooftop swamp coolers are probably the cheapest, most effective use of electricity for AC in hot, arid locations. But I'm no expert on that.