Former Liverpool and Newcastle manager Rafael Benitez is returning to management after being named Celta Vigo boss.