Hi! Welcome to the forum,
One place you may want to consider is the Grand Palladium in Lucea. I was there this Feb and it will fit all your requirements. It was affordable, and fun for all ages. I am 25, and my fiance, sister & husband (30's), Mom, Aunt & Uncle(60's) all had a great time. It is not to far from Montego Bay so there is plenty to do, but you dont hear airport noise. The zipline was awesome, and it is a 3hr drive to Ocho Rios for Dunn's River and Dolphin swimming.
Plus, the rooms were really great! We were in bldg 14, 1st floor. We opened our patio door, and literally stepped down right in front of the ocean. All in all, this was fun for all ages. Hope this helps