The famous daredevils who walked tightropes over Niagara Falls were not from a particular museum, but rather were individual performers who were known for their daring feats.
You might be thinking of the Niagara Falls State Park, which features a variety of attractions related to the history of the Falls, including the history of daredevils. However, there is no museum specifically dedicated to daredevils.