No, there are no dedicated studios at Aulani. Just like at BLT, AKV-Kidani, and now VGF, DVD is designing resorts with only Grand Villas, two-bedroom lockoffs, and two-bedroom dedicated vacation homes.
We were in villa #304, a pool view studio on the third floor overlooking the Menehune bridge and water play area. The water feature was turned on around 8:00 AM and ran until 6:00 PM, and it was noisy due to the splashing water, sounds from the kids, and the background music that is played in Waikolohe Valley. It was noisy enough that it was difficult for me to carry on a cell phone conversation while on the balcony, but not noisy enough to interfere with normal conservation with someone sitting with me on the balcony.
As carissa1970 posted, the villas have really good soundproofing and when we closed our balcony door we didn't notice any of the noisy.
More importantly, we found the noise to be a "white" noise that was easy to ignore. I actually enjoyed hearing the music and other sounds.
Views are so subjective that its hard to answer that part of your post. The Ocean Views start on the 6th floor and you can check the views from some of these OV villas by looking at the list in Post #1.
As for room requests, I'm not sure how specific you can be with your request. I know when we go back to Aulani in October 2014, we'll ask for an Ocean View Studio that overlooks Waikolohe Valley as the primary request and high floor as a secondary request.