Ronen Hoffman in an emotional Twitter post thanks officials for the opportunity to serve abroad, but explains he cannot continue his role over ‘personal and professional integrity’