Caddieshack star to caddie at US Open