There are 12 volt water pumps you can use. They will however be a drain on your battery. The more pump volume and the pressure the more current draw.
If you bring it into your city hookup, you will of course have stream water in your entire water system; though not your fresh water tank, unless your check valve does not work.
I must say that any number of times I have canoed to the center to of a lake, to get beyond the off shore water, to pump drinking water through my 5 micron and charcoal filtered hand pump; Only to return and find the family swimming and diving at the shore line.
Most of the lakes I know of are not filled with bottled water. Many things in life just have a certain amount of risk.