Coupled Cluster Green's function formulations based on the effective Hamiltonians