Well, not particularly where I am, it's quite normal in Scotland. I've lived in and worked in social housing and we came across the full gamut of people. After all, the First Minister and probably most of the MSPs grew up in social housing. Loads are being built, and social housing can no longer be bought, by tenants or anyone else.
My LA is both building their own, training many apprentices into the bargain, and having developers provide a certain number of social houses - identical - in any new development. In my village, there's a couple of streets of HA social and middle-rent properties being built at the moment, right across the road from a brand new couple of private streets and, frankly, the HA looks nicer and better built... The occupiers are likely to be pretty similar too.
Yes, there are certain areas over the LA with problems which is not surprising given the extreme levels of poverty which have got worse over the Tories' omnishambles, but the LA is pretty tough on anti-social behaviour, given that it made history by getting an ASBO to bar an owner-occupier from their property due to ASB.
I will always be grateful to the LA for being rehoused as homeless after a private tenant rendered my owned one bedroom flat uninhabitable (according to Environmental Health and my insurance) and the shyster landlord refused to accept responsibility. It took two years before my insurance finally gave up and repaired it with their own funds, by which time i had been living in a two-bedroom flat for over a year. I had been given an allowance for decorating and, during the three years I was there, I had new heating, a new kitchen (which I got to choose), external and loft insulation, a shower installed over the bath, and replastering of sitting room, stairs and hall after my removal of wallpaper showed the walls to need it. All free. It was two streets away from my own flat, in a much quieter area and with more 'respectable' tenants than the private lets I was surrounded by in my own flat who were always being raided for drugs, setting fire to things and leaving rubbish lying around. The tenants were in falling-apart private lets because the LA refused to rent to them because of their bad behaviour.