Behind the Tate’s £260m extension: the people, the art, the architecture and the city that made it happen