Sir Vince Cable has become the new leader of the Liberal Democrats with a promise to offer voters the possibility of an "exit from Brexit" through a second referendum on EU membership.