As you live in Sheung Shui, you'll find that the nearest public hospital is the North District Hospital. It is also the newest in HK and has excellent facilities in general. However it is not available for giving birth. For that, you have to go to the Prince of Wales or the Tuen Mun ones.
For antenatal care, there is a mother and baby clinic in Fanling Government Offices