Depends on the supernova. You can just barely see some nebula. The great nebula in orion for example looks like a hazy patch to the naked eye you can just barely make out. Simple binoculars will give you a decent view of the core.
A supernova's brightness varies greatly. The one 400 years ago was so bright it could be seen in the day time at its peak.