A disappearing fountain gives you the spray and sound of water, without the open pond. It can be a pretty cool visual effect, as the water will disappear into your base. The smaller water basin makes for a greener solution, requiring less water. This can be a good choice if you have children or pets that you don't want to worry about falling into a pond, and don't care about having plants or fish.
There are great looking ready-made fountains, and fountain kits available on the market. Unfortunately, even a modest outdoor ready-made water feature starts at several hundred dollars and can easily run into the thousands. The pre-made components (e.g. basin) required to piece together your own creation really aren't any cheaper by the time you're done. Our goal is to build an in-ground fountain with inexpensive, easy to find materials. Depending on your specific needs, you can probably get it done for less than $100 ($200 including decorative rock).