The support from the referendum will boost Carney’s ambitions to get a major pipeline out of Alberta that he hopes could revive the economy