No longer the preserve of nobility, tapestries can blend old and new to striking effect, writes Francesca Perry