I want to switch off the water in the bathroom only due to replacing sink taps, will water still come out of the pipe if i turn the stop valve
Assuming that the stop valves are good, turning them off will stop the flow of water to the sink taps. To test them, turn on the water faucet at the sink, then turn off both stop valves. The water should stop coming out of the faucet. If it continues to drip, the stop valves are defective and should be replaced when you do the job. If this is the case you'll have to shut off the main water valve or a valve upstream of the stops to replace them. Good Luck
Water should be off to the sink is the stop valve off
Only water what is still in the pipes will come out but you will lose all your hot water in the hot water cistern if you have that type of hot water storage tank.