Make sure you book a time slot to see the memorial http://www.nps.gov/valr/planyourvisit/feesandreservations.htm
A tripod and such will be helpful, and rain covers (seems to rain just after sunset the nights I was there).
Diamond Head is a popular shot from Waikiki as is Ko Olina Beach Park for that sunset shooting west. I didn't stop in Hanauma Bay, but really, it'll be amazing anywhere you go. The north shore area isn't that far away, so many options.
Make sure you plan things with where the sun will be at that time using http://photoephemeris.com/
Also know that any rental car there has been rented by a local to make a copy of the key - never leave your gear in the car, even in the trunk.