Not some lavish place your own water source/river physics (Cities Skylines).
Just a decoration (perhaps a grill at either end to show in and out) that can be tiled together (so only “end parts” showed the grills).
Could also serve as sewage management (obviously compost amounts would need tweaking) and/or water source.