Sadly, I don't have the space for such a feature but even a smaller bird bath or even a circular try would do the trick.
Succulents hold water in their leaves or stems and as such, can withstand more arid climates or dry soil conditions. Botanically, cacti are succulents but not all succulents are cacti.
This one is loaded with Sedums and Sempervivums.
They are great in any garden and hardy once established. They are easy to care for, come in a variety of striking colors and textures but do like full sun.