long exposure - How can I get smooth water and a city skyline including the city light with a bright sky?

The water surface looks so smooth and the lights have the rays coming out. What are the techniques to get such image? What kind of camera settings a dslr camera should have?