Back to Feed Composite structure for MEMS applications, comprising a deformable layer and a piezoelectric layer, and associated fabrication process