A lot will depend on how much water people use and if there is water pressure.
There are ways to DIY with a black painted oil drum with black painted garden hose etc. I’m not sure to what you extent you want to experiment or not.
There are various alternatives on the market but they all do all the same and look all the same.
Ideally, you should have a drawing with some distances, details on the quality of the water, maybe you need a filter system, where the water will come from (pressure?), and maybe a picture of the set-up of the site. You can send this to us to have a look or give it to a supplier to cost up.