Garden lighting has to be subtle and used with a delicate intent. You should try and place the lights so they don't shine directly into your eyes so you just see the glow and reflection from a distance. Water and light work perfectly together as the light dissipates through the water to give a soft glow as well as giving you a look at what the pond life is doing.
Always set your night lights on an automatic timing system so they are always coming on without you having to worry. Brendan will set his timing systems from around 6pm to midnight all depending on the season and also for just 10 minutes or so at 3pm.
Brendan sets up both LED and normal Watt systems with his LED system running 8 or so lights for only 20 watts all depending on distance. There are some great LED globes that you can now put in your existing systems, you will have to change your transformer though.