Grand Designs presenter Kevin McCloud discovers the vision for the new Tate Britain, in the second of a three-part series celebrating the opening of the new gallery