A lot of the notes I see on sheet music relate to the notes being sung in the melody more than anything, and can quite easily be played on piano. The thing you are talking about when hold the chord shape and playing the individual notes is finger-picking or finger-style playing. What you will most likely want to find is the TABLATURE for the song. This is another way of showing the notes and chords as they relate to guitar. A lot of song books, for guitar, will say "with tablature" on the front cover. These are the ones you want as they describe not only the individual notes and chords being played, but HOW to play those notes.. whether you bend the note, slide up to (or down from) the note, and so on. Tablature (tab) makes a lot more sense than just sheet music from a guitarist's point of view.