We were in Rome last year when this happened (by chance, not by planning) and it is just spectacular! Museums have free admission at midnight and stay open all nite, streets are blocked off and bands are playing, people roam the streets everywhere and staying up until the sun rises!
See http://travelguides.lastminute.com/sisp/index.htm?fx=event&event_id=99553