In wind tunnel tests, the cantilever sting supporting system often suffers from low-frequency and large-amplitude resonance due to its inherent low structural damping characteristic, resulting in the degradation of data quality and structural safety. To improve wind tunnel testing safety and data accuracy, this paper is dedicated to establish an active vibration control system using piezoelectric stack actuators. A novel methodology of vibration monitoring based on modal transformation, which uses measured strain and a Strain-to-Displacement Transformation (SDT) matrix to reconstruct dynamic displacement field, is proposed herein. Meanwhile, strain sensor positions are optimized by an improved Particle Swarm Optimization (PSO) algorithm to reduce systematic estimation errors of this method. Furthermore, a Back-Propagated Neutral Network (BPNN) is established to implement a self-adaptive control strategy. A series of verification tests are performed to demonstrate the validity of the proposed system. Experimental results indicate that the relative Root Mean Square Error (RMSE) between estimated vibration displacement and measured vibration displacement is less than 3%, and a vibration attenuation of over 14 dB/Hz is achieved in ground tests, proving the superiority of this intelligent active vibration suppression system.