Prime Minister’s Office confirms ex-agent died when boat overturned: ‘Impossible to elaborate’ on his service, praises dedication ‘even after retirement’; body returned to Israel