So back to the drawing board. In an amazing stroke of luck, I found an indoor/outdoor fountain on craigslist for $35. It's definitely more money than I had anticipated spending but it has a wonderful roar. Since I've plugged it in, I haven't been disturbed by my neighbors and it drowns out the sound of traffic. I also found out that the fountain retails for $200+ and so I've rationalized my splurge beautifully.
There was a small crack in the middle bowl that a bit of sealant fixed perfectly.
I did have to lay down a splash guard because the fountain creates a trace mist. I covered the plastic with a couple of natural rock mosaic tiles. A dozen succulents finish the tropical oasis.
And a short video that somewhat captures the sound:
All in all, I'm very pleased with how the oasis turned out.
Let me know what you think :)