K.R.
There's the Children's Museum or the Durham Western Heritage Museum (my son calls it The Train Museum) has various themes for parties (not just train stuff). I know some have gone to the water park (in the hotel, can't remember the name) but I think that's expensive...
I liked the idea you were given of a YMCA swim party - we did that once for a winter b-day and it went over well!