No they will only let you in the water park if your staying there.
I think you can but cost is Depending on availability
At one point before the pandemic they sold day passes and the cost was based on crowd level. Cost ran between $65 and$100 power day per person. They have not reinstituted this practice yet.
Thanks! Your answer is awaiting moderation.