Framingham, MA has a geothermal system using ground source heat pumps like what you are describing
https://www.smartcitiesdive.com/news/first-networked-geother...