A new chief medical officer for Wales will be in post from next month, as Dr Sir Frank Atherton prepares to step down from the role after eight-and-a-half years.