New Constructions of Complete Non-cyclic Hadamard Matrices, Related Function Families and LCZ Sequences