‘Throughout his life, he showed us what it means to be a practitioner of good works and a good and faithful servant of God and of the people,’ Biden said Thursday at a service attended by all living presidents