Head of spy agency describes 50-year-old retired agent as 'pioneering' in his expertise, carried out many significant actions on behalf of Israel