The Portuguese park was awarded the title of Europe's Leading Water Park for 2025, and in addition to indoor and outdoor areas, it has an onsite hotel