President Obama faces a knotty decision in whether to approve the much-delayed Keystone oil pipeline: a choice between alienating environmental advocates who overwhelmingly supported his candidacy or causing a deep and perhaps lasting rift with Canada.