The training of social workers in England needs upgrading, with more emphasis put on practical skills, a government adviser has said.