Modal acoustics will provide you the eigen frequencies of the fluid geometry.
Harmonic acoustics is when you have a source with a sinusoidal output. The load is specified as an amplitude of the sinusoid. The analysis sweeps the frequency of the source over a specified range and you can see the amplitude and phase response in any part of the space.
Transient Structural is needed to see a single pressure pulse travel through the fluid.