Just a short walk or vaporetto ride from the bustle of St Mark’s Square, this artsy district is where locals – and in-the-know tourists – hang out, says Emma O’Reilly