I've worked in both Venice and Rome and I couldn't recommend anywhere more highly than them both
However I was working a 8-6 shift at the time and I got to see very little of the day but the nights were fantastic, good food, drink and the scenery is breath taking
Edit: I was going to recommend May