Is there any scene in Naruto where the destruction of the Uzumaki clan was shown? I think I saw somewhere that the leader of the Uzumaki clan used some jutsu and literally commited suicide while destroying everything around him.
No, there's no scene. Uzushiogakure was destroyed by some of the world's nations banding together out of the fear that it was too powerful.