Lawrence Pollard presents a packed show from Nottingham. When it opens on 14 November, the Nottingham Contemporary will be one of the biggest art centres in the UK. Tom Dyckhoff explores the new building designed by award-winning architects Caruso St John