thanks for the help everybody ive killed the demon and returned back, to which point my mage lead character was given the sphere, does this only happen if you are a mage?

Yes. This is your characters specific stronghold quest. For myself, I got De'Arnise Hold as mine.

Syl...