Where can I get it?

That might actually be an interesting game to play.

Is it in stores? Do you have to order it? Download it?

You can most likely purchase it on the Elder Scrolls website (elderscrolls.com or morrowind.com). I've played the demo for it. It was pretty cool.