What's worked for me for 16 years of year round use, winter, spring, summer, fall, is a 1/2hp-110v shallow well pump & 30 gal, vertical tank located in the kitchen, next to the refrigerator. It draws from a 125' x 1 1/4" poly vinyl butyl, black flexible hose feeding from a depth of five feet in the lake with a foot valve at the lower end. Other than the foot valve screen, and the aerator screens on the kitchen-bath sink, it has no filter, no reverse osmosis, no chlorine.....just lake water...and I'm healthy as a horse...and just as smart.
To keep from freezing, it has a 333 watt internal, inside the hose, heat wire, on a thermostat. Installed everything, myelf, in November 1992, and so far, no problems....knock on black vinyl butyl tubing.... One year, forgot to turn on the 15a circuit breaker, and the water line froze up in early January. Switched the breaker to "on" and 12 hours later, the water was flowing.
Excuse me while I pat myself on the back....pat..pat..pat...I am the greatest unlicensed plumber in the history of the world...or at least since they invented water
!