The Picts liked to blend drama, devotion and mystery in their sculptures - or so it seems to us now - and this is one of their most spectacular offerings