Part of the problem with cities like Venice is that there ends up being this large cost to preservation and limits on development which pushes the city to become a form of historic theme park in its best condition or a ruin in its worst.
The city can try to control the worst parts of tourism, but I feel like Venice is a city doomed to needing tourism to survive.