I live in a new build estate. It has half million pound houses on it. It also had a batch of social housing - some shared ownership and some rented though a housing association.
Some of the locals were incredibly snobby about it when it was built. They went on about it being a 'council estate'.
In reality its one of the nicest and most sort estates in the area now. It has a nice park which parents with their young kids come to from outside the estate.
The only way we could afford our first house was through shared ownership. We eventually bought out the other half. As part of our shared ownership we had to pay a rent to the housing association and agree to terms with them over how we behaved. They did an inspection once or twice a year to ensure there were 'no unsightly things outside the property' that shouldn't be there. It was actually stricter than you might image.
The entire estate (including where the big houses are) is also managed by a management company, who maintain it and ensure the greenery is well maintained and the street lighting is working etc. This is because many new build estate roads are not adopted by the council, because councils are relutant to take on those costs. There is therefore a small fee for this.
I do therefore wonder if your new estate will be subject to any of this.
The reality is you'd never know which houses were 'social houses' on our estate unless you were told. There isn't a social divide. Just bigger and smaller houses. Our next door neighbour is still on the scheme and I can honestly say she's been a brilliant neighbour.
The local council take our estate as a model which they want to repeat. Its success has been good and now the local feeling is very much in favour of more such schemes. Even the NIMBYs are on board with the idea in principle these days!
I do get pissed off at the automatic assumption that 'social housing' means 'problems'. Its not true. Done well its brilliant. It helps people and its good for social cohension rather than rich and poor living completely separate lives.
If you have concerns about this, ask the sales person! Ask who the housing association is and what contracts in terms of behaviour there are. Ask if the estate will be managed (and whether there is a fee due to you for this). You might be pleasantly surprised to find out that consideration has been given about this.