Well, I have such a small yard (square yards, not fractional acres) that I have trouble imagining constructing a dam and a reservoir.
But I can see where that COULD divert enough water from a river, for use in later seasons, that the resulting absorption & evaporation or transpiration made a difference down-stream.
I wish we could divert some of the runoff from WA to CO or CA!