Localized oscillations in conservative or dissipative networks of weakly coupled autonomous oscillators