I like to live near a pub, however not too near because we actually lived about 100 yards from one for a few years.
At first it was fine, cosy, a bit scruffy, a 'no drugs' pub. Sometimes there was music on a weekend but only during the day. Nice to pop over for a pie and a pint.
Then it changed hands and was 'modernised'. It lost what had made it a nice pub. It became noisy at night, we had drunks pissing in the garden and one day I found a turd complete with paper.
There was also the entertainment as the drunks made their way home on foot, yelling, and the 'domestics' outside the house.
There were drunk drivers crashing outside, more than once.
The reviews changed from good to as bad as they could get and eventually it closed down. It is now being converted to a supermarket which is going to cause a lot of disruption to anyone who lives near it, deliveries, customers blocking drives etc.
So, I would say be careful how close you are to the pub.