According to the author of 2 Chronicles, this verse is asking God to come to His special place and be with His people, bringing strength and happiness. It also asks that God's helpers be filled with goodness and that everyone be joyful.
2 Chronicles 6:41: Now therefore arise, O LORD God, into thy resting place, thou, and the ark of thy strength: let thy priests, O LORD God, be clothed with salvation, and let thy saints rejoice in goodness.
While 2 Chronicles 6:41 speaks of God arising to his resting place, Psalm 132:8 refers to God rising and going to a place, highlighting a notion of movement rather than rest.
Psalm 132:8: Arise, O LORD, into thy rest; thou, and the ark of thy strength.