If you are poor, should you really be going to Venice?
A reasonably priced lottery would give middle income people access and an even playing field against wealthy people.
This system, combined with a limit on tourist infrastructure would cut down on excessive visitors and make it sustainable.