Acoustic flows in viscous fluid: a lattice Boltzmann study