How to enjoy the fountain without having to water it often
That is right. Simply by using in the over all design a range of cactai seedlings you have the idea tierred garden.
The larger growing , while bigger spreading cactai would be best place around the foot, but away from, the base of the fountain.
Smaller cactai acting as though they are part of a pertual water fall would draw the viewers attention towards the waterfall focus point.
Thus in areas and times of low water fall the overall 'free falling' mood is created.