V8 Supercars' executive chairman Tony Cochrane is to retire from his role at the end of the season.