Does drinking water have any effect on your fasting blood test?

No. Drinking water is fine. In most cases you will fast overnight, eating nothing and drinking nothing but water after your evening meal and in the morning before your blood is drawn.