Spectroscopic studies, antimicrobial activity, and computational investigations of hydrazone ligands endowed metal chelates