The birds like it

 Flipped the fountain rock over.  Well, not really flipped.  The thing weighs a lot.  More like rolled it over in place.

The side up now has a natural bowl so water can stay on the top of the stone.

The kind of weird brown blob on the top in the water is a bird bathing and splashing.

This bird is just taking a drink.

I used the male part of a hose coupler as a kind of stopper and flow control.  The hose coupler prevents the water coming from the pump from going back down the same hole.

I also changed the rocks at the base from more of the flat limestone to these river rocks.