Democratic presidential candidate was loyal to the president during his White House tenure, but remained a steadfast friend to Israel and acted as a key interlocutor, insiders say