I'm a local councillor and I love what I do (although after 10 yrs you could say that I've simply become institutionalised!)
That said, it is not an environment for the faint-hearted, and the sheer nastiness is sometimes breathtaking. Most women find the Council Chamber, with it cat-calling and barracking, very daunting - it took me about three years to say anything much at all.
I had my 4th child a few years ago, and breastfeeding in the Council Chamber certainly raised a few eyebrows (the last cllr to give birth whilst in office - some 20 yrs previously - had actually been ejected from the chamber for breastfeeding - so slowly things change).
Yes the evening meetings can be difficult. They are largely full of old men with nothing else to do who would be happy to bore on all night about a point of order, although sometimes I found a good argument cathartic after a day at home with toddlers.
Most women don't have the time or energy for this sort of war of attrition. Being villified in the press (the local press can be just as viscious as the nationals) was awful, particularly for my older children who could read the articles.
I'm acutely aware that I gave up a career as a teacher and any hope of a pension to do this, but that the electorate could kick me out at the next election.
Most difficult is that you are constantly on call - phone calls from constituents at all hours, stopped at the shops etc. It can be impossible to set aside family time.