If you're seeking a modern look, there are interesting glass fountains available. These usually have a sheet of glass in a wood or metal frame, and water cascades over the glass. Often the glass has a design or pattern on it, and sometimes these fountains come with colored lights.
Best Garden Shop Phoenix 2011 - Relics Architectural Home and Garden
The guys at Relics do all the work for you, poor souls: They travel to Europe to personally select cool old stuff for their shop — and, by association, you. At Relics, they specialize in antique architectural and garden features — think hand-carved fountains, shabby-chic pottery, and architectural ironwork. If you are doing some landscaping, Relics is a great place to stop in to look for special items.