As a dog owner, I totally support the council.
I don't let my dog foul in areas that others use, she's trained not to defecate whilst out. (It wasn't hard). I hate treading in dog mess, and I can understand that others don't like it much either, especially children's parents. Kids get excited and don't always look where they're treading, but why should they in a play area?
As my dog is large (Alsatian) I wouldn't consider letting her run free. She's always on the lead unless I'm along the canal path and can see clearly ahead that there's nobody about. Other people don't share my liking of dogs, why should they be subject to a big dog running up to them and sniffing them? As regards street walking, to let her walk behind me (which she happily would) isn't an option. What if she decided to run off across the road, caused an accident etc.?
Unfortunately, the irresponsible owners are yet again ruining things for the responsible ones, which is why the council feel the need to introduce legislation like this. People need to understand that with dog ownership comes responsibility.
(Rant over

)