Not sure about the longevity of the pump, but in theory it will
work. You have to remember that you WILL need a filter at the lake end!
Central machinery is not the greatest and personally I wouldn't buy anything
electric made under that name. I have bought many things from HF and found a
few problems. I have never had any problems with the air tools though. I
just seem to have a problem with electrical items from them. Tractor supply
is where I get my pumps from. If I were doing what you are planning I would
buy a trash pump and a filter. I would also use a much larger than garden
hose. The first property that I looked at had a large stream on it, I had
the same thoughts as you. Now, I have a 3 55gal poly drum set up for
collecting rain runoff from my roof for watering my gardens. Who ever heard
of having to pay for water?... I have lived on well water all my life, until
now that is.

Searcher