New legislation means councils will have to transform the way they deliver social care, offering people choice and control over the support they need.