Water features like waterfalls or fountains, encourages water movement and aeration within the pool. This is a positive thing! Water movement keeps the available water fresh and aerated. Oxygenated water will be better for the ecosystem and any life within.
These are also attractive additions to a pool, and add significant appeal for a natural look.