From Carolina Beach head north to the Northern Extension Pier. If you can't find free parking you will have to pay a fee. These old pilings are a couple hundred yards past the pier.
This picture was taken shortly after sunset during the blue hour. It is a long exposure, 2 minutes. I used a flashlight to paint the pilings and waves. In Camera Raw I made three exposures of the same image +1, 0, -1 and processed them in Photomatix. I did further editing in Photoshop.