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.