Officials say they believe risk of a catastrophic explosion has been eliminated at a damaged chemical tank in California