This is the source for many quests least of all the building where Hawk reunited with Aveline, after his first year in kirkwall.
It serves as home to the Viscount of Kirkwall.
Its where you find one of the hidden Enigma's of kirkwall during Act One.
And is the final scene of Act Two.