Will they let us into the water Park without staying at th resort?

Thank you Mr. Allan

This link has lots of info: https://www.massresort.com/play/waterpark/

yes!

Yes but it's best to call to make sure they aren't sold out. Once they sell out and reach capacity they won't allow you in the waterpark.