Mikel Arteta's return to Arsenal as manager has been confirmed after the former midfielder quit his role as No 2 to Pep Guardiola at Manchester City.