How is the “cantilever” problem fixed?
The best answer is “don’t use it”. The new lower deck will be constructed totally outside of the house structure. It will attach to the house on one side and be supported by posts on the other. This design eliminates the possibility of water leaking into the structure where the deck joins meets the house.