I live on a new build estate in SE prices for a flat from £300k up to £650k houses. Our house is opposite social housing - reduced rent ones. Apparently the terms is you have to have one person working on a low income. Many are taxi drivers. There are also council tenant flats in a block, so I don't think they have to work, but they may do . Plus there are shared ownership and privately owned homes.
We haven't had any problems, particularly, but the one thing I would say is they all let their children play out. Now other children do play out too, but the social ones are out all weathers. Actually very nice polite kids, but that is a factor it may bother you?
Some other roads have had issues with the social children playing out but it maybe they are just snobby like me.
My observations on new builds is most people don't buy a new build as they love gardening. Most houses whether social rent or private have overgrown front gardens. Many have broken down beds, car seats and yes the occasional washing machine outside. I do not know that the majority these are the social houses, but I can guess they might be ( and sometimes I see the housing association van visiting.) Annoying as the dump is about 5 miles away.
The block of flats is by some shops built as part of the new development, they have had issues with vandalism.
Would I buy here again. Yes. It is generally a nice community. I knew we were taking a risk, but as other posters say they mix in the social housing.
Before I lived in a small development of 6 properties. When we moved in we didn't realise our neighbour was renting / council tentant. But then she disappeared, lots of Bailiffs later the landlady was paid mega bucks to house a problem family. And they were a problem. Bad luck, it can happen anywhere. Hence we moved.