Biden's pick for US spy chief played a central role in Obama's secretive drone war that resulted in hundreds of civilian deaths