Psalm 23

I have one question about the well known psalm. Where is God's dwelling which the psalmist referenced at the end of the psalm? Was it the temple? Was it the household of Israel? Was it the eternal presence of God? What ideas would have come to the minds of those early worshipers who knew the tune to these words? I think the idea intended was a never ending love relationship with God. But I could be wrong.
Stuart