Your waterpark will be available at a certain point of progress in your theme park. Don't worry if you find waterpark missions in your quest list. That means that you will be able to unlock the new park very soon.