AC Studio's diorama in N Scale work is fantastic. It's exactly what I'm aiming for as far as my own work goes. Rich detail and fantastic scene work abound in this series or photos.
JAPAN TRAIN MODEL- N GAUGE
He also gives a fantastic breakdown of how he gets the layout built up from the base up. Well worth a look for any modeler, really - it's a great, step-by-step look at his process that was very helpful.
As I stated before, I had planned on having a fishing area with boats for a while, but seeing this layout has filled me with SO MANY ideas that I'm very excited about starting the process. I'm also planning to use some of these techniques on my main Soyokaze module as well!