if I stay overnight in Venice, I won’t have to pay the access fee?

Yes, you only need a reservation.*

*If you only stay in an accomodation facility in the Municipality of Venice.