Sources say US president responded 'affirmatively' to request from Egypt's Sissi, but move faces opposition in Pentagon and among some top advisers