Mac,
I have an open-loop geothermal system as opposed to the closed loop systems described.
It draws water from the well, runs it through the heat pump, and then discards the water to a stream we have in back.
It takes about 5 GPM to heat and 7 GPM to cool our 4500 SQ FT home,
This is the second geothermal unit that we have had over the past 25 years.
We have a good water table only 70 ft down and have not issues with the open loop concept other than occasionally cleaning the water lines for mineral buildup.
Since we also use the well for the house, there was not much extra expense with the installation.
We live in Indiana and this keeps the the house warm down to about 5 DegF without aux electric heat.
I would consider using geothermal again.
If I had gas available, I would also consider a regular high efficiency air-air heat pump with a high efficiency gas furnace.
You would be able to run on the heat pump 90+% of the time with the gas furnace kicking in below 15-20 DegF.
If you are considering a closed loop heat pump, do your homework and find a contractor that has a lot of experience and long term references. The issues that I have heard about involve extended heating seasons where the loop systems were undersized. THey work great at the beginning of the season but by the end of the season, you have drawn enough heat from the earth that the loops freeze up (even with anti-freeze).