My B in law is looking to do a G source heat pump but he has a small lake/pond, How big practically does it need to be to heat a 3 bedroom house with UFH?
His lake is about 25m by 10m by 2m. You get a lot of heat lowering a few hundred tonnes of water a couple of degrees. If he needs to get a digger on site would he be better enlarging the lake than burying 400m of pipe?
Is there water flowing into and out of the lake? If so, then the chances are it'll be OK. If not, then you may need to do an in-depth assessment to make sure that there isn't a chance of freezing the lake at depth. The latter point is key, as there may be a significant risk to flora and fauna in the lake, which may or may not be a legal issue.
In crude terms, if the lake was a rectangular box of the dimensions given and starts the heating season at around 12 deg C and ends the heating season at around 4 deg C, then ignoring the large heat loss that would normally occur to the ground and surrounding air, and ignoring any additional solar input through the heating season, there would be about 16,720 MJ of heat available. If we assume that about half this will be lost naturally, then there could be around 8,000 MJ of heat energy the pump could use over the heating season. This is about 2,200 kWh, so not a great deal - enough to supply about 1 kW of heat all day and night for 90 days. In practice I think the actual heat recovery from a lake of this size might be a bit less than this, as the guesstimates above are pretty rough and crude.
Edited to add:
The rough calculations I used above (which may be in error!) were:
Specific heat of water = 4.18 J/g.K
Volume of lake = 25 x 10 x 2 = 500 mē so mass of lake = 5 x 10^8 g
Energy per deg K in lake = 5 x 10^8 x 4.18 = 2.09 x 10^9 J.K
Energy for an 8 K drop = 2.09 x 10^9 x 8 = 1.672 x 10^10 J = 16,720 MJ = 4,644 kWh