Manchester City won their first Women's Super League title in 10 years, marking a major achievement in English women's football.