Plans to transform a former public house, which closed in August, into a new multi-purpose community hub have been confirmed.