Amazing location! Doesn’t get much better than that, easy to reach by vaporetto and close enough to all of the main sites in Venice. Definitely recommended. The only detail; nights in summer gets really warm and opening the windows allows the mosquitoes to come in and bite; closing them means a rather hot environment. There are fans available which help a lot but it is a bit on the warm side anyway.
Nevertheless I’d definitely recommend it!