It's become rather a photography cliche to recommend a 'sturdy tripod' for general photography, but it's sound advice when it comes to night photography. You'll be working with long exposures, even with the aperture at its largest setting.
Watch this quick instructional photography video and discover how to do extreme macro photography without having any real specialized macro photo equipment. Use a couple of your existing lenses to create a super macro lens. Practice these tips and improve your photography skills.