Martin O'Neill resigns as Villa manager