Sounds like you are combining both ideas somehow? The Corsi-Rosenthal box radiator in your sink would absolutely work. Though I don't know how much water you would be going through for it.
If you instead used a closed loop and pumped water through the ground to cool off then the only thing going is the pump and fan.
Condensation is a possible issue, tray and bucket to collect it?