I just want to heat with it. I thought water at or below 10 feet deep is always around 50 degrees due to the ground temp below.

Why is a closed loop so expensive? In principle it's just a big coil of tubing in the water to transfer heat energy to.