It's for registered guest only and you can buy passes for family for the day. But 1 has to be a registered guest.
According to the faq's on the website it says the waterpark is reserved for registered guests only.
I have seen day passes but you would have to actually call them for details.
Thanks! Your answer is awaiting moderation.