I don't want to offend, but in my experience some council estates are awful, especially to strangers. We lived on two apparently 'nice' estates. Some people were friendly, including our neighbours, but many weren't, they were very territorial. Feral teens roamed around in packs, really intimidating. The things they did, with no control was shocking. The houses weren't great, the second one was damp and mouldy in every room. Water ran down the bedroom walls.
We lived on another estate (in an ex-LA house) with a bit of a bad reputation, but it was lovely. Quite gossipy, but really friendly. The kids in the street asked DS1 to come and play on our first day there. The house was amazing, thick walls, no damp, it was solid. The garden was huge. We only moved because the landlord sold it. I'd definitely have bought it if we were in a position to at the time.
We've lived all over, in rough areas and great ones and the only bad experiences we've had were on those first two council estates. The third one was lovely though, so my advice is to do your research, talk to people who live there and go there at different times of the day and night to get a proper feel of the place.