Celtic have appointed Wilfried Nancy as their new head coach, prizing him from Columbus Crew and ending a more than month-long search for a permanent successor to Brendan Rodgers.