To be honest Terri, there are a number of variables that you need to address -- with each one having a direct impact on the image:
1. Shutterspeed. If you can get a reallllly loooong shutterspeed then it smooths out the water whilst getting you a sharper image at the same time, but of course for that, you need to be shooting from a tripod. If you're serious about your photography then a tripod is probably the first thing you need to look at (for landscape anyway)
2. Time of day. Usually there's a 1/2 hour "golden hour" at the start and end of the day (just before sunrise and just after sunset) - you'll get better colours at that time.
3. Remote release (you'll need it for the looooong exposures)
In terms of lenses, the short answer is "whatever focal length gives you the field of view that you want" - nothing more, nothing less. For sure, you can get better image quality from a lens that costs 10 times as much, but I wouldn't be too concerned about that at this stage.
In terms of exposure - shooting scenes at night with what we call "point light sources" in them (eg house or street lights) will generally cause issues with standard camera metering; the camera tries (unsuccessfully) to protect the brightest spots from blowing out, so the end result is typically a significantly under-exposed image that still has blown point light sources. The "trick" is to use manual exposure, and just concentrate on getting the midtones right.
Here's a couple of examples to illustrate the above -- the first I shot with a long exposure - at the right time of the day - with the right lens (I chose it as an example because it was a similar view to yours), and the 2nd, because it has lots of blown point light sources, but because the midtones are OK, the image still works.
Hope this helps.