Go to this place. There is no better option to stay in Venice. It has everything you need including A/C.
You are located 15-20 minutes walk to each place in the city. „Bus station“ in 3 minutes walk. A lot of restaurants and bars in 1 Minute walk. It is very quiet and absolutely stunning. At day tourists passing by making photos of the location (without being annoying).