The transfer of public health responsibilities to local government has largely been successful, according to reports by two leading think tanks, but more needs to be done to embed it across all services.