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.

[1] https://www.artic.edu/visit/whos-visiting/families-2