One metal pail.
One very cheap fountain pump.
Sink in ground, plug in and enjoy.
This is right by my walkway to my front door. It produces the most wonderful bubbling sound and does drowned out a bit of the traffic noise. Easy to make, fun to enjoy.