A proposal to convert a pub into a house has been rejected amid major public objection