If you want the real Venetian feel, I recommend this house. It's an old, small house in a residential neighborhood, right in front of water canal. The water-bus stop is very close to the house (2 mins walk). All the must-visit places are near-by, or at a max 20 mins walk. The host was great and gave great recommendations. He also speaks fluent English and responds quickly on Airbnb message chat.
PS - the TV has Netflix, in case there's flooding and you have to watch TV.