Would you consider apartments in one building?
A few years ago, we spent a month in this 2-bedroom, 2-bath apartment near the Rialto Bridge. It is one of 4 two-bedroom apartments in the same building, one on each floor (with an elevator). Lion’s House No. 4 is the top floor and one room is a sort of loft, with a door to the rooftop terrace, which we really enjoyed, every evening. The other apartments (Lion 1, 2, and 3) each have 2 regular bedrooms. I will put a link to Lion 4 and Lion 3 so you can see the difference.
https://veniceredhouse.com/apartments-in-venice/the-lions-house-apartment-lion-4/
https://veniceredhouse.com/apartments-in-venice/the-lions-house-apartment-lion-3/
The location is just about ideal, on little Campo San Lio, with a grocery store just down the street. It is pretty much in the center of Venice, where the sestriere of San Marco, Castello, and Cannaregio all meet.
You could email Marco at Venice Red House and ask if all 4 apartments are available for your dates.