The credit outlook for some local governments has turned negative with a one-in-three chance of a credit ratings downgrade over the next two years.