Good old Ancient and Modern for all the traditional ones, New English Hymnal, for the alternative tunes.For the more modern set - try Songs and Hymns of Fellowship - a mix of the most popular trads and newer songs, from about 1970 onwards.
Or try the Spring Harvest song book - great for both lively and spiritual moments.
What I really want is a book that has all the old gutbusters in, like 'Bringing in the sheaves', 'What a friend we have', 'Blessed Assurance' and 'Mine eyes have seen the glory'..... guess who likes a good stomp!
LTS