Ex-Manchester United legend named manager of relegation-threatened League Two club who were linked with Steven Gerrard