You can't take it with you, but you can't leave it for someone else either: Valve says you aren't allowed to bequeath a Steam account in a will

They can't, but if you don't give you password and safety codes away before you die they can't legally let you transfer ownership of the games. Just don't tell them and arrange for all your emails, security keys, and 2FA keys to be safely transfered to your children.