The site of a much-hyped $45 million water park development on the Captain Cook Highway north of Cairns has hit the market for sale with existing approvals to revive the project.