No, a waterfall will not create CO2.
Water is H2O.
Mixing it around will not make it magically *poof* become a different compound.
The only application for a waterfall in your grow would be oxygenation of your res water.