Do I need to buy a separate ticket for Splash Bay Water Park?

No, it is included in your general entry ticket.