can you imagine the complexity of designing, implementing and renovating a sewer system in a historical millenia-old city built on water?

While I have limited knowledge about the exact construction of Venice. I’d imagine localised aerobic septic systems would be a tolerable solution. The water coming out of those will have a slight mildewy/musty smell to it but is (allegedly) potable.