Women who served as councillors across Scotland have faced threats of violence racist abuse, and sexual harassment during their time in office, as new figures reveal that one in three female councillors stepped down at the 2022 election.