Dundee-born director still has faith in future of the arts, ahead of major BBC drama release