You sure know the intro from Redguard (if not: http://www.elderscrolls.com/redguard/).

Are the art works from this video availible somewhere in complete?

Well, the map used to be available for download from the official Redguard website back when the game was new, and can probably be found on TIL, UESP and other fansites now. But the rest, no.