Alternate tripod suggestions: 1. Monopod; 2. Tabletop tripod (mine is an old Leitz).
As for hotels, when we went in 1982 we stayed at the Hotel Bocassini, on the back side of Venice from San Marco. It was inexpensive, quiet, and quaint. We loved it. I was pleasantly surprised recently to find it on Google Earth, still under the same name!