The Canadian firm behind the Keystone XL pipeline has given up on completing the project after a decade of controversy, environmentalist declare victory.