Yes, it might make your semen more watery and lower your sperm count due to Finasteride's action on the prostate. It won't have any effect on children unless your wife is handling/taking Finasteride while she's pregnant.
That being said, it's not going to make you impotent, I wouldn't feel comfortable using finasteride as a form of birth control