BHP has announced its chief executive will step down after more than six years, marking a major leadership shift at the mining giant.