Plans to turn a terraced house on a street with “significant traffic issues” into a butcher shop has been refused.