Less than a quarter of local politicians are confident that major NHS plans to reshape local health and care services will succeed, according to a new survey by the Local Government Association.