A garden fountain like this can be created from an old metal plate or just about anything flat that will deflect the water. Again, you have to be careful of the type of metal or materials you use and especially if you plan to have fish or plants in the water.
Simply attaching the plate to a wall or stand and pumping the water into it from above will create sound and motion. However, unless you like the sound of loud metal, you should make sure the object you use will hold an inch or so of water in the base. Otherwise, the sound of the water dripping directly on the metal may get to be a bit annoying.