Pep Guardiola has been named League Managers' Association Manager of the Year after guiding Manchester City to the Premier League title.