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 Oasis Phoenix 2011 - Optima Camelview Village
It's not often that a building turns out looking exactly like the architectural drawing that inspired it. But somehow, Optima's location just north of Scottsdale Fashion Square materialized into a modern version of the famed hanging gardens of Babylon, chock-full of lush climbing plants and beautiful flowering bushes with blossoms the muted orange and purple colors of an Arizona sunset. The multi-tiered complex — which houses condos, restaurants, shops, and an art gallery — boasts a massive central courtyard, with gorgeous fountains and plush sitting areas dotted with colorful couches. The bottom floor of the open expanse offers an amazing view of the whole building, and it always makes us feel as though we're vacationing in a tropical paradise, without ever leaving the desert.