Agricultural water intake system