A tank like reservoir sits in the ground.
A grate is placed over the opening and the fountain placed on-top, supported by a cinder-block or two.
Gravel/Mexican Pebbles is used to cover the top, creating the illusion that water is disappearing into the ground.