Canadian indigenous deal with KXL oil pipeline took years, aims to unlock long-term wealth