I have the petmate fountain, the large one and I love it!! They get nice clean water and it stays nice and cool. The furkids really enjoy it as well and it is very quiet so no problems there.
I do prefer stainless steel over plastic but it is dishwasher safe so you can sanitize it pretty well. Just make sure you take it apart and clean it well and replace the filters when necessary.
They do have one that has stainless steel....
Petmate Deluxe Fresh Flow Pet Cat Dog Fountain Black - eBay (item 360248790024 end time Apr-30-10 14:49:09 PDT)