We visited Tikehau & Bora Bora in November 2002. If you want to stay where you have a great view of the main island on Bora Bora, any of the resorts on motus will do the job handily. The catch is you need to use the resort's (free) water taxi service back & forth from the main island. This was never really an inconvenience for us.
We meant to go visit the sites with the defense guns still in place, but never quite got around to it. Something in one of the dive magazine reviews about the setting and couples emerging from the bungalows with 'bunga-glow' each day rang true for us.
Y'all will have a great honeymoon!
We took a bungalow on stilts on Bora Bora, like a Robinson Crusoe house. We stayed in a bungalow over the water on Tikehau and wanted to try both options. I think we actually enjoyed the bungalow on stilts better as we had more privacy. We were at the top of the row of bungalows - the one we stayed in had the tallest stilts.
http://www.sofitel.com/sofitel/fichehotel/gb/sof/resort/2755/fiche_hotel.shtml
FWIW, some of the best snorkeling around Bora Bora is right by the Sofitel Motu sub-island. You will see snorkeling boats come to the area, but we just had to walk down to the beach and back side of the motu, gear up, and go snorkeling on our own schedule (and just the 2 of us). And, most often, we could pick to go snorkeling when there weren't any snorkel tour boats around. I think we wound up with more 'keeper' U/W photos from our snorkeling than our diving - but the U/W camera was a new toy for us then as well. So, don't forget to try some snorkeling in the mix of activities there.
Loads of dining options. But research a bit before you go (I love the Internet for travel planning!)