Your son will love Adventure Ocean. Different activities are planned each day. The counselors are great! They will assign you a beeper so that they can contact you if they need to.
I would recommend any tour that is not too long! Kids get bored on long bus rides. The beach is always a great excursion with maybe a little snorkeling too!