Concerned as much with the future as the past, a programme of highly acclaimed exhibitions capture the excitement of design evolution, ingenuity and inspiration through the twentieth and twenty-first centuries