Well, if you finish Frank's storyline, but stay his bro (no romance), he will tolerate you if you are getting the booze.You can also run Frank's own story and make him run off in shame at the end of it. I think they should also consider implementing if Frank's relationship bar gets high enough he stops caring if other people drink or not, just because it's kind of strange that he can be in love with the player but still physically attack them if he catches them drinking
By tolerate, I mean getting negative relations and he nagging you any time you take it until relations get very low. Then he will attack as before.