An Afghanistan veteran and defence intelligence chief has been appointed as the new boss of the Border Force.