Gerard Houllier will become only the second foreign manager in Aston Villa's history when named as Martin O'Neill's successor.