Weighted Total Least Squares with Singular Covariance Matrices Subject to Weighted and Hard Constraints