Is there going to be another Legend of Zelda game?

If you're talking about after TP and PH, then yes there will. Miyamoto hinted it off, and we assume there will be a new Wii game along with a new DS game. This is only an assumption, but there definetely will be a new one in the future.