I love Hackney, live in Clapton too, just off murder mile too!!! We've lived in Clapton for 8 years and I think its getting better not worse.
Clapton is a friendly place, we have proper neighbours we really know who babysit, the kids can play out because the roads are gated, you can buy anything you've ever dreamt of and a few you haven't from Palm2 at Clapton Pond.
King's Hall doesn't always smell of wee, my kids swim there qute happily. It is only partially open at the moment because of the fire but you can swim there and it will all be open soon.
Lizardqueen my kids go to Millfields, I teach there, we all love it. Mrs OhHU if you live just the other side of Lower Clapton Road then you should be in the catchment for Millfields. Hackney has plenty of more than decentish primary schools, secondary is more of a problem but is improving.
I don't find the council that much crapper than any other I've lived.
My real top tip for living in Hackney is don't read the Hackney Crime Weekly!!