In the play (and later movie), “La Cage aux Folles” is the name of the night club owned by Renato. The name refers to the “crazy things” that go on there (drag queens! oh my!) rather than to a mental institution as such.
The word “folly” (as in Ziegfeld Follies) is from the same origin.