Former Scotland captain Paul Lambert has agreed to be the new manager of Livingston when his contract ends at Celtic at the end of the season.