Yorkshire Water has announced its chief executive is stepping down - a day after the company was given the lowest environmental rating by regulators.