A new show looks at the Renaissance artist’s role as a designer and head of a busy workshop as well as the inventor of an instantly recognisable style