I believe sleepovers are privately hosted events. Your best bet would be to contact the Aquarium directly to find out who is hosting one, then contact that organization.
You can't sleep over at the aquarium but I'm not sure how much it is for a hotel room.
Thanks! Your answer is awaiting moderation.