The actor became an overnight sensation after making his debut as Eddie Munson in the fourth season of the supernatural