The Glacier Bay Waterfalls page is basically my excuse to showcase the beauty of Glacier Bay National Park (especially on a sunny day) along with many of its unnamed cascades spilling into bay.
I don't think we'd encountered any major waterfalls that would warrant special attention or have a name in the area. But I think the convergence of at least five major tidal glaciers as well as a handful of other hanging receded glaciers all within this Y-shaped inlet area (encompassing both the Johns Hopkins and Tarr Inlets) was what really made this place special.
The major glaciers we saw were the Reid Glacier, Lamplugh Glacier (very beautiful), Johns Hopkins Glacier, Grand Pacific Glacier, and the Marjerie Glacier (also very beautiful).
I don't recall the exact locations of the various cascades I'm showcasing on this page, but I don't think it really matters in the grand scheme of things. I'll just let the pictures do the talking.
Since this was seen on day 2 of our Seattle to Glacier Bay and back cruise via the Inside Passage, all I can say is that this area can only be accessed by boat and most people do it as a cruise from either Seattle or Vancouver. There may also be options from Anchorage or other Alaskan ports, but I'm not sure.
Your cruise company can probably give you more information on getting to the docks where the cruise ship departs.