Oil pipeline will face fierce opposition in Canada as well as in the United States, where the permitting process is currently underway