I like to use bi-color LEDs that flash green for signal present, and red for clipping or near clipping.
There are very simple transistor based approaches but often because of diode drop thresholds they don't indicate very low for signal present, and/or may only indicate for one polarity.
I would suggest looking for app notes on a comparator IC like LM339, that should be pretty simple to make signal present indicator with good sensitivity. Note: for a peak detector it is often useful to add some hold capability so you can better see brief transients, for the signal present a hold circuit is not necessary.
JR
Note: comparators have very high input impedance and can be driven directly.