Can the Chief Justice of the United States overturn a Supreme Court decision?

Not by himself. The Chief Justice has different responsibilities from the Associate Justices, but has no more voting power than they do. In order to reach a decision on any case, including one that overturns a previous US Supreme Court ruling, a simple majority of the Justices must agree on a verdict.