Brendan Rodgers has agreed to become the new Celtic manager, taking over at Parkhead for the second time in his managerial career after Ange Postecoglou's recent departure.