Algae, or lack of isn't really a reason to install/not install aeration. I think aeration is a good idea anywhere you have non-moving, wind protected water. It will definitely help with beneficial bacteria and other items such as dying blooms at night that rob O2.
Sounds like a really cool idea to harness the power of falling water to make it work.
