I would ask for Martinique or Trinidad North to be close to the food court. As far as the buses I never saw a lot of people waiting when I was there last week so I don't think catching a bus will be a problem. We always drive so I can't tell you about the buses. If you read the FAQ listed below other people have commented on the buses. They do have an internal bus to take you around CBR but if you are staying in the two villages I have listed above you won't need it.
We have no problems with 2 in the double beds. Yes you can rent the water sprites. On my web site I have a picture of the sign at the marina with the prices to rent boats, bikes.
We have stayed in Aruba, Trinidad North, Martinique and I haven't had a noisy area yet. Also stayed on first and second floor, waterview, standard view, parking lot view, and haven't had a problem with the noise.
October is a great time to go. It isn't as hot or crowded as other times of the year.
You will love CBR.