After portraying figures from Tony Blair to Brian Clough, actor Michael Sheen is to star as Prince Andrew.