Building a wall water fountain is no easy endeavor. You will
need a lower water reservoir, an upper hood and the main section of
the fountain usually stone or metal.
The upper hood and water reservoir will need to be secured to
the wall with screws directly in to the wood studs for stability.
The main stone section needs to be fitted with a bracket on the
back using masonry screws. The bracket in turn will then be secured
to the wall and wall studs to support the stone section. The upper
and lower sections of the stone then fit into the hood and
reservoir.
A water pump can be housed in the lower reservoir with tubing
attached which reached up to the top of the stone from behind. You
will need some kind of trough to attach the tubing to which
disperses the water from the tube over the stone section
evenly.
Building a wall fountain from scratch can be done, but it's
probably easier to purchase a wall water fountain kit with all the
parts and install it.