The Art Institute of Chicago goes out of its way to be family friendly and not take itself too seriously [1], and it is consistently seen as one of the best art museums in the world.
PS - the Children’s Museum in Indianapolis is ridiculously good for kids.