CE, it really is he who has the problem, notyou, but you're suffering his problem. Yes, your breasts are lent to the baby right now, but he will regain access to them eventually. I think most dads go through this 'breast-jealousy', but yoour dp seems to be struggling more than most to cope with it.
He really does seem to be traumatised by the whole affair, and is acting in a childish and excessively testosterone-driven way by not addressing his problems. Such a shame that you have to cope withh the results.
It's very difficult not to see every positive thing he does as "Hooray - we've finally turned the corner! He'll be alright now.", but it isn't that way. You can't expect all this to be over so easily. It's a dance - 2 steps forward, 1 to the side and 1 back. Gradually - we hope! - things will improve.
As for th HV, she should be able to get in touch with your local HV and help start setting up a support network for you. I moved house when I was pg with ds2, and my HV contacted my new HV-to-be in order to get things started. We were concerned about the PND (I hadn't had it with no2, but now I was moving away from family and friends, to a completely strange area, I didn't want to fall off the radar IYSWIM)