Lake water help.

I just acquired a farm up in Central Texas that uses water from the Colorado River. On the 22 acres and surrounding farms there have been numerous attempts to drill water wells but they were either dry or yield very little flow. Old time water well drillers in the area just laugh at the possibility of getting a good well in.

The river water is ok but I am tired of rocks and sand in the house lines and having to bring bottled water in. I met with three area people on what to do.

What do you need to run a river water system that works and is self cleaning? Are there any other sites that offer basic information on using river water systems?