Present work introduces an aggregation-induced emission (AIE) active Schiff base 4,4'-((1E,1'E)-([1,1'-biphenyl]-4,4'-diylbis(azaneylylidene))bis(methaneylylidene))bis(5-(hydroxymethyl)-2-methylpyridin-3-ol) (BNPY). Schiff base BNPY was synthesized by reacting benzidine with pyridoxal. The non-fluorescent BNPY in freely soluble DMSO medium showed a significant fluorescence enhancement at 563 nm (lambda(ex)=400 nm) upon increasing the water fraction (fw) in DMSO above 60% due to the restriction of intramolecular rotation upon the aggregation of BNPY. The AIE active BNPY was employed for the detection of metal ions in DMSO:H2O (fw=70%). Upon the addition of Fe3+, the fluorescence emission of BNPY at 563 nm was quenched due to the chelation-enhanced fluorescence quenching (CHEQ). The Job's plot experiment supported the formation of a complex between BNPY and Fe3+ in 1:2 binding ratio. With an estimated detection limit of 5.6x10(-7) M, BNPY was employed to detect and quantify Fe3+ ion in real water samples with satisfactory recovery percentages. Moreover, the pH studies of BNPY aggregates revealed three different fluorescence windows: non-fluorescent in acidic pH 2.02 to 3.16, yellow fluorescent between pH 3.60 to 9.33, and green fluorescent in basic pH 9.96 to 12.86.