The effect of adding water to a garden cannot be understated. The sound of running water is very therapeutic and relaxing. How about an informal pond with lilies, marginal planting and maybe stocked with fish. Most features work on the same principle of a sump, pump, and outlet hose feeding the visible feature, be it an urn, statue, drilled rock or cascading down a watercourse. Almost anything can be custom built to your requirements.