The all-cash deal will make the Canadian company a major force in the distribution of natural gas produced in the northeastern United States.