There are close to 300 fountains in Rome. I know I haven't even seen half of them. Many times I'm running errands or on my way to meet a friend and boom, I "discover" a new fountain.
There is something soothing and even sexy about being surrounded by all these fountains.
In L.A. we have the fountain in Grove which is a big Vegasy thing in the middle of a mall. The owner of the Grove, like the founder of Starbucks, was inspired by his travels in Italy. I don't blame him. They are inspiring.
Some are more about function, some are works of art and they are part of the neighborhood. You don't have to go to a mall to see them.
I'm linking to Lola's great POST on fountains. She has a bunch of outstanding photos.
Lola grew up in Italy and works in film. Her mom is Italian and her father is American. She has spent a lot of time in States and it's interesting to read her POV on Rome, Italy, etc. She's an incredible writer and cook.
I you love Italy, Rome, food, or just excellent writing check out her blog.