The notification noise is presumably the equivalent to the shutter sound when you take a picture, so that you know that you've started recording. Some camera apps allow you to silence the shutter sound, some don't. Open the camera's settings and see if there is an option to do silence it. If not, you could search for other 3rd party camera apps that might have that feature.