The Duke of Sussex tells PEOPLE that his children have relationships with some of his family members, which brings him "great joy"