Wall fountains and garden geysers are ideal for 3D landscaping and your public space ArchViz scenes
Japanese Rain Chain
This is used similarly to a downpipe but the water goes down the chain from funnel to funnel, rather than a pipe.