Plans to turn a North Yorkshire village pub into homes have been rejected by council planners who heard the business was “vibrant and lively” before its closure.