Great for small locations and can be incorporated with reflecting pools in larger locations if that is the look that you are looking for.
This type of element can be exciting and add drama to any landscape when illuminated at night either with a spot light or an LED light strip in the water stream.
And for added interest the stone that you choose for the water basin can be quite decorative all depending on what is available to you.