Plumbing work is a regulated trade and should ONLY BE DONE by licensed plumbers. Maintaining airtightness can be planned ahead of time - involve your plumber in the planning process to make sure it's done properly.
Sealing around pipes that enter and exit the building envelope must be done with material that is resistant to moisture and flexible to move with the expansion and shrinkage of metal pipes.
Some considerations: