Premier League legend, 49, takes over as manager of non-league minnows