A fountain just mixes the top 3 or so feet of water, and can leave bottom water devoid of O2. A properly sized bottom aeration system will mix the entire volume of water in the pond.

IMHO fountains have a place as emergency aeration in addition to their ornamental value.

"Live like you'll die tomorrow, but manage your grass like you'll live forever."
-S. M. Stirling
[Linked Image from i.pinimg.com]