A suspect in a rare fatal shooting in Japan has reportedly died after ending an 18-hour stand-off with police by shooting himself in the stomach.