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.