It sounds like drumming with a stick over a simple tin can turned upside down.
I have noticed it many times, but in particularly in a couple of songs featuring Slash:
Music Fans Stack Exchange is a question and answer site for music historians, critics, and fans. It only takes a minute to sign up.Sign up to join this community
It sounds like a cowbell to me. The "Cowbells in popular music" section of the "Cowbell (instrument)" Wikipedia page notes that Guns N' Roses have often used the cowbell, notably in "Nightrain," "Welcome to the Jungle," and "It's So Easy."