The reason these people have no motivation and are depressed, or get addicted to drugs and alcohol, is because they can't see any other way to escape from the grim realities of a life where there just AREN'T any jobs that can support their family, they can barely afford to live properly (rather than just survive) on benefits, their priorities get skewed (mini motorbikes for the DC's when they haven't got a house in a sensible state of decoration) because they want their children to have what everyone else does.
I have lived on an estate like this, and it is a soul destroying place to bring your DC's up on. I was lucky - after 7 years, I managed to exchange off that estate to an estate that was totally different - simply because of better public transport links to the town centre, and more local jobs, with FT hours, that paid a tiny bit above NMW, due to the local industrial estate offering many more options for employment.
That is literally the only difference, but this estate has a totally different 'feel' about it, there's not anywhere as much ASB, and the only real difference is the opportunities for employment.
You want to improve estates like this? Give them something to aim for, drag employers into those areas, build a business park or industrial estate there, offer more FT ABOVE NMW jobs to the people living there. The difference is immense, and there isn't the same sense of helplessness and hopelessness.