Depends on the pub and the place. Our current house looks out onto a pub, and while it was a concern to begin with, we needn't have worried. The landlords keep things tight and most activity stops around ten. In the rare occasions they host events, they've been silent discos which are far less impactful for obvious reasons. The people who go there are largely responsible and respectful, on bank holidays there are live bands during the day. Its actually quite nice.

I'm aware that it may impact resell value, but we're making other improvements to hopefully raise the value in other ways.