Reverse pumps exist so you can actually generate when you allow flow and pump when you push electricity. The issue is, can’t find them small scale. If you find something for flow that fits your case, please let me know.
Discussion
This is a handy calculator btw: https://www.omnicalculator.com/ecology/hydroelectric-power
What is that called or do you have an example of one? Sounds interesting!