It's probably more to do with the size of the hole rather than the size of the dick. The noise is made by the force of the water, so it's more to do with the force it's put out at, and the size of your pee hole. Imagine putting your thumb over the end of a hose pipe, it increases the pressure of the water, making more noise.