On the Detectability of Visible-wavelength Line Emission from the Local Circumgalactic and Intergalactic Medium