KAYSEE,
Here's a link to a picture that is (somewhat) like what you are wanting to model. The battleship is not the Arizona, but it may give you an idea for your model layout!
http://www.rememberingpearlharbor.org/images/pearlharborattack.jpg
Here's the Arizona burning in the aftermath of the attack:
http://www.history.navy.mil/photos/images/h97000/h97378.jpg
Like Hans Von Hammer said, a shadow box or forced perspective diorama is your better option for a dio like you've described, otherwise your viewers may wonder why you built 2 different sized models for one dio. But who knows, you may build this without forced perspective and pull it off very well and teach us all something new?!
I am no expert on water, but use the Forum Search tool to find some other posts on how to make water; like anything there are many different ways to portray water. I also recommend Shepherd Paine's book "How to Build Diormas;" there is a good section in there about methods for modeling water. I've also heard of using part of a frosted shower door with the texturing on it; then painting it various shades of blues or greens or whatever color you want you water to be! Cut out where your ship will be, then use clear acrylic caulk (bathroom sealant) for waves and water around the ship; it will come out of the tube white, but dry clear. Then brush paint your waves as desired.
As for the smoke cloud, for a neat idea look in the 2009 issue of Great Scale Modeling, page 46--there is a Red Baron vs. Snoopy aerial vignette and the modeler used "Halloween cobwebs colored with chalks" to make a smoke trail. Pretty cool, I think!
To have a flying model, you will need to use some sort of rod. Most of the ones I have seen are clear acrylic, with a diameter large enough to support the weight of the built airplane model. I'd say search/look in the Aircraft forum for tips--there are modelers there who can fill you in on the details of "suspending" an in-flight aircraft.
Hope this all helps you out! Good luck and keep us posted!