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