Man, that’s a difficult shot that I feel AE isn’t really set up for. Even if you took footage of waves, it would just look like footage over your still. Not knowing what the setup for the scene is like, you might need waves to crash into buildings or around them for that matter.
If you can live with out the waves crashing against it and all that, then AE can do something about it but it’s not going to look AMAZINGLY real. Video your wave, either do a BEST match of the stills angle with your eye or shoot it all from top view. Then create masks, cut out all your buildings in the stills.. whats in the forground .. where the water is going up too and all that stuff. Then turn your footage into a 3d layer and or corner pin it so that the agle matches (it’s going to look square if you use the top view footage). As for the water coming into the shot, good luck?? 😛
Here is 2 other set ups that would look great 😛
Build a small model of everything in a fish tank and well, get the camera lined up .. make sure all your buildings are green screened or even just grey / white or black (depending on your transfer) and then fill it 😛
Failing that,
Depending on what your budget allows get 3d programs with some wave setups or hire a company to do it :P. Realwave or Realflow would do the trick, and then there is Glu3d now and a few others. You would need to set up the gemoetry of the scene in 3d and then you let the software solve the waves.
Other then that, that’s all I can really think off.
Good luck, tricky setup.
..::hunz..