A new chief executive is set to take over at Lancashire County Council.