Naming someone/legacy to have the ability to access the information in my account.

There is no provision for this to happen automatically. You will have to leave instructions for your legacy contact to carry out and they can request the account be erased after your death.

See here: link How to add a Legacy Contact for your Apple ID - Apple Support

and here: How to delete your Apple ID account - Apple Support

Hello Ralph,

In connection with the How to delete your Apple ID account article, you should make your wishes known for Apple to be notified.

Legal - iCloud - Apple

IV. D. No Right of Survivorship

Except as allowed under Digital Legacy and unless otherwise required by law, you agree that your Account is non-transferable and that any rights to your Apple ID or content within your Account terminate upon your death. Upon receipt of a copy of a death certificate your Account may be terminated and all content within your Account deleted. Contact iCloud Support at iCloud - Official Apple Support for further assistance.

Also note the section "About Estate Planning" in this document How to request access to a deceased family member's Apple account - Apple Support

You may wish to even be specific about this in your will since some people may wish to have access to a deceased person's data for the purpose of getting photos etc. Make it clear what you want done.