The waterpark is located to the east of Kato Paphos, i.e. to the direction opposite to the harbour and castle. Especially with kids, this is a must visit attraction.