Da Mr. Brian P. David
This is the end result of letting the Lord be our shepherd. We are filled with the desire for what is good ("goodness") and have full awareness that we are loved by the Lord ("mercy"), and these will be sustained in all spiritual states we encounter ("days of my life"). The "house of the Lord" is heaven itself, and to be there forever means to eternity.
The fact is that the Lord created each one of us for heaven, and works unceasingly to guide us to heaven. He won't force us, because it would destroy our humanity, but if we let Him He will take us there, fill us with love and wisdom, set our evils aside and love us infinitely and eternally.
It's interesting, though, that the word "dwell" is used here. Generally, to dwell somewhere implies a degree of impermanence; it's more significant than visiting but less significant than "living" or "inhabiting." The Writings don't say, but it could be that this indicates the fact that even in heaven, we are only there because the Lord keeps us there, and even the highest angels would turn to hell if the Lord withdrew from them. We get dwell there, but heaven is the Lord's house, not ours.