The green light has been given for a $60m expansion to build the largest waterpark on the Sunshine Coast, despite community backlash.