The fountain of Neptune (notice the water-spouting water nymphs around the base) sits in the Piazza Nettuno by Bologna's Basilica of San Petronio. It's prohibited to take photos inside the churches, so I never do, but I wish I could have. The basilica contains the world's largest sundial.
At night, the piazzas become public living rooms, complete with tables, chairs, and couches, with food and drinks served by the surrounding restaurants and bars. This is the Piazza S. Prospero in Reggio.