In what does God have pleasure when he examines the heart?

Yahweh examines the heart and has pleasure in uprightness.

What made David look with joy on God's people who were present?

He looked with joy as they willingly offered gifts to Yahweh.