I have not experienced any hostility, but I can believe that some ordinary people as well as marina staff might have adverse feelings about the matter.
When I was calling around for rates, inquiring if the marina allowed liveaboards, a few times I got a tentative "Uh...yesss"
. The first thing I did was assure them that my boat was in good repair, visually appealing, that I am neat and tidy, have no pets, and that I would definitely be sailing, and not permanently attached to the pier. This would usually evoke a relieved sigh and an invitation to come on down.
The marina I settled on is not luxurious. No swimming pool or tennis courts but it is absolutely wonderful. It's small, sheltered, quaint, has a very cool antique club-house, is a short motor to the "raise sail" point, and by and large, I like my neighbors just fine.
I'm blessed/lucky and I know it.