The water-spraying stone carving beads you mentioned are called Feng Shui balls in the stone carving industry. As shown in the figure below,
The lower part of the sphere is hollowed out, and a groove is made according to the size of the Feng Shui Ball. A water pump with sufficient power is installed below, and the water is pumped up through a pre-built water pipe, so that the water flow can drive the Feng Shui Ball to rotate.