I was browsing through Tom Sutcliffe's site the other day and he has an excellent tutorial on tying the Ed Herbst hopper. This is a great little pattern for any stream and works quite well on still waters as well. My rendition isn't quite a neat as either Ed's or Tom's but they certainly do the trick.
Have a look on Tom's site, The Spirit of Fly Fishing, for the Step by step. While there check out the rest of Tom's site for some other patterns and some stunning photography..